Restore

Restore your files/database to the original or alternation location.

Key:

Field Description
Select what to restore For database restore, only one option is available, ie. 'Choose from files as of job'.
Restore Raw File The option is for advanced Oracle user and should only be used if you have in-depth knowledge and understanding of Oracle database, otherwise you are not suggested to use this restore option as there is need of using additional Oracle technique to make manual restore. Please refer to the article of Oracle Database Backup and Recovery User's Guide for details: https://docs.oracle.com/database/121/BRADV/title.htm.
Restore database to Choose the destination for restore the file/database to, ie. 'Original location' or 'Alternate location'.
Oracle Home This is the path for the Oracle binaries.
Host This is the hostname of the Oracle server. Default using 127.0.0.1.
Port This is the Oracle server port number. Default is 1521.
SID A database is referenced by at least one Oracle instance which is uniquely identified from any other instance on this computer by an Oracle System Identifier (SID).
Password This is the password for the system user account in the new database.
Confirm password Confirm the password for the system user account in the new database.
Database Area Specify locations for the database files to be restored.
Control file Filename Control file name to be restored to be.
Control file File Directory Specify the locations for control file to be restored.
Data files Filename Data files name to be restored to be.
Data files File Directory Specify the locations for data files to be restored.
Redo Log Groups Filename Redo log groups file name to be restored to be.
Redo Log Groups File Directory Specify the locations for the redo log groups to be restored.
Flash Recovery Area This is used as the default for all disk based backup and recovery operations, and is also required for automatic disk based backup using Enterprise Manager. Oracle recommends that the database files and recovery files be located on physically different disks for data protection and performance.
Temporary Directory This is the temporary directory for files to be restored to.


To restore Oracle backup set:

  1. Click on the storage that you want to restore the backup from.
  2. Select the backup snapshot from the 'Select what to restore' drop down box. You can also select the date and time of the backup from the date and time drop down box.
  3. Select the database(s)/files that you want to restore from the file tree. Click on the [+] in the file tree to expand the tree, [-] to collapse the tree. Click on the check box, all the files under the check box will be selected.
  4. Click on [Next].
  5. Select 'Restore databases to' to choose restore location.

    For Original location:

    For Alternate location:


  6. Click on [Restore] to begin the restore process.
  7. For alternate location, need to enter the Windows user login credentials to start the restore process.